<?php require_once('connections/con_gl.php'); require_once("excel/excelwriter.class.php");?>

<?php

cekAkses($_SESSION[akses],"L-3");

echo $_SESSION[nama];

mysql_select_db($database_con_gl, $con_gl);

mysql_query("delete from gl_trans where total='0'", $con_gl);

$currentPage = $_SERVER["PHP_SELF"];



$maxRows_data = 20;

$pageNum_data = 0;

if (isset($_GET['pageNum_data'])) {

  $pageNum_data = $_GET['pageNum_data'];

}

$startRow_data = $pageNum_data * $maxRows_data;

$cr_txt = str_replace("+"," ",$_REQUEST[cr_txt]);

mysql_select_db($database_con_gl, $con_gl);

$query_data = "SELECT * from v_kasir a inner join v_kendaraan b on a.kendaraan = b.nopolisi";
$query_korporate = "SELECT * from v_kasir_korporate a inner join v_kendaraan b on a.kendaraan = b.nopolisi";

/*
if(!strstr($_SESSION[akses],'A-1-4')) {

	$query_data .= " AND gudang='$_SESSION[gudang]'";

}
*/
if($_GET[gudang]<>'ALL' AND $_GET[gudang]<>'') { 

$query_data .=" where a.gudang='$_GET[gudang]'";
$query_korporate  .=" where a.namagudang='$_GET[gudang]'";

}
else{
$query_data .=" where a.gudang='$_SESSION[outlet]'";
$query_korporate  .=" where a.namagudang='$_SESSION[outlet]'";
}
if($_GET[cr_txt]<>'' AND $_GET[cr_txt]<>'+') { 

$decode_cr = str_replace("+"," ",$_GET[cr_txt]);

$query_data .=" AND (a.no_ref LIKE '%%$decode_cr%%' OR a.nama LIKE '%%$decode_cr%%' OR a.paket LIKE '%%$decode_cr%%')";
$query_korporate .=" AND (a.no_ref LIKE '%%$decode_cr%%' OR a.kontrak LIKE '%%$decode_cr%%')";

}



if($_GET[mulai]<>'' AND $_GET[sampai]<>'') { 

$query_data .=" AND a.checkin between '$_GET[mulai]' AND '$_GET[sampai]'";
$query_korporate .=" AND a.mulai between '$_GET[mulai]' AND '$_GET[sampai]'";
}


//print_r($query_data);
if(!isset($_GET['mulai']) && !isset($_GET['sampai']))
{
 
}
else
{
$mulai =$_GET['mulai'];
$akhir =$_GET['sampai'];
$query_data .=" order by a.checkin desc";
$query_korporate .=" order by a.mulai desc";


$cekdata = mysql_query($query_data, $con_gl) or die(mysql_error());
$row_data = mysql_fetch_assoc($cekdata);

$cekdatakorporate = mysql_query($query_korporate, $con_gl) or die(mysql_error());
$row_datakorporate = mysql_fetch_assoc($cekdatakorporate);
}



include('include/widget_export_hasilsewa.php');

?>

<link href="css/ui.datepicker.css" type="text/css" rel="stylesheet" />

<script language="javascript">

function download()

{

	window.location='report_penjualan.xls';

}

</script>

<script type="text/javascript" src="js/ui.datepicker.js"></script>

<script type="text/javascript">

<!--

$(function()

      {

        $('.calendar').datepicker({

            appendText : "",

            dateFormat : 'yy/mm/dd'

          });

      });

</script>

<script type="text/javascript">

$(document).ready(function(){

$(".flipsearch").click(function(){

	$("form.tanggalsearch").hide() 

    $(".objsearch").slideToggle("fast");

  });

});



$(document).ready(function(){

$(".fliptanggal").click(function(){

	$("form.objsearch").hide();

    $(".tanggalsearch").slideToggle("fast");

  });

});

</script>

<h2>LAPORAN HASIL SEWA KENDARAAN</h2>

<table width="100%" border="0" align="center" cellpadding="5" cellspacing="0" class="datatable"> 

  <tr valign="top" bgcolor="#FFFFFF" class="hide">

    <td> Pencarian</td>

    <td colspan="11" align="left"><?php

	mysql_select_db($database_con_gl, $con_gl);

$query_cr_gud = "SELECT id, gudang FROM gl_gudang";

if(!strstr($_SESSION[akses],'A-1-4')) {

	$query_cr_gud .= " where id='$_SESSION[lokasi]' ";

}

$query_cr_gud .= " ORDER BY gudang ASC";

$cr_gud = mysql_query($query_cr_gud, $con_gl) or die(mysql_error());

$row_cr_gud = mysql_fetch_assoc($cr_gud);

$totalRows_cr_gud = mysql_num_rows($cr_gud);

?>

	<form id="search" name="search" method="post" action="">

<label><select name="cr_gudang">

	      <option value="ALL">Pilih Cabang</option>

	      <?php

do {  

?>

	      <option value="<?php echo $row_cr_gud['gudang']?>" <?php if($_GET['gudang']==$row_cr_gud['gudang']) echo "selected"; ?>><?php echo $row_cr_gud['gudang']?></option>

	      <?php

} while ($row_cr_gud = mysql_fetch_assoc($cr_gud));

  $rows = mysql_num_rows($cr_gud);

  if($rows > 0) {

      mysql_data_seek($cr_gud, 0);

	  $row_cr_gud = mysql_fetch_assoc($cr_gud);

  }

?>

        </select></label>

	    <label>

      Tanggal : 
      <input name="mulai" type="text" id="mulai" value="<?php echo $_GET[mulai];?>" size="15" maxlength="15" class="calendar"/>
	    </label> 
	    s/d <label>
	    <input name="sampai" type="text" id="sampai" value="<?php echo $_GET[sampai];?>" size="15" maxlength="15" class="calendar"/>
	    </label>

		<label>

      Kata Kunci : <input name="cr_txt" type="text" id="cr_txt" placeholder="Find by: no.referensi,nama,paket"; onclick="this.value='';"<?php echo $_REQUEST['cr_txt'];?>" size="40" maxlength="100"/>
        </label>

        <label>

      <input name="Search" type="submit" id="Search" value="Search" />
        </label>
	  </form>

	<?php

	if(isset($_POST['Search'])) {

		echo "<script>window.location=\"index.php?component=hasilsewa&mulai=".$_POST[mulai]."&sampai=".$_POST[sampai]."&cr_txt=".str_replace(" ","+",$_POST[cr_txt])."&gudang=".$_POST[cr_gudang]."\";</script>";

	}

	?></td>
  </tr>   
   <tr bgcolor="#CCCCCC">
      <th width="200">CSO/Marketing</th>
   <th width="78"><strong>Berangkat</strong></th>
    <th width="100"><strong>No Order</strong></th>
	<th width="80">No. Kendaraan</th>
	<th width="300">Merk Kendaraan</th>
	<th width="100">Periode Awal</th>
	<th width="100">Periode Akhir</th>
	<th width="250">Customer </th>    
    <th width="100" align="center"><strong>T.Sewa</strong></th>
    <th width="100" align="center"><strong>T.Bayar</strong></th>
    <th width="100" align="center"><strong>Piutang</strong></th>
    </tr>
	
	      <tr valign="top">
          <td colspan="11" align="left"><strong>SEWA KENDARAAN RETAIL</strong></td>
        </tr>
        <?php do { ?>
        <tr valign="top">
          <td align="left"><?php echo $row_data['cso'];?></td>
          <td align="left"><?php echo $row_data['checkin'];?></td>
          <td align="left"><?php echo $row_data['no_ref']; ?></td>
          <td><?php echo $row_data['kendaraan']; ?></td>
          <td><?php echo $row_data['merk'].'-'.$row_data['tipekendaraan']; ?></td>
          <td><?php echo $row_data['tgl']; ?></td>
          <td><?php echo $row_data['jatuhtempo']; ?></td>
          <td><?php echo $row_data['nama']; ?></td>
          <td align="right"><?php echo number_format($row_data['totalsewa'],0,',','.').",-"; ?></td>
          <td align="right"><?php echo number_format($row_data['totalbayar'],0,',','.').",-"; ?></td>
          <td align="right"><?php echo number_format($row_data['sisakekurangan'],0,',','.').",-"; ?></td>
        </tr>
			<?php 
        $totalsewa += $row_data['totalsewa'];
        $totalbayar += $row_data['totalbayar'];
        $totalsisa += $row_data['sisakekurangan'];
        } while ($row_data = mysql_fetch_assoc($cekdata)); ?>
        <tr valign="top">
          <td colspan="8" align="center"><span style="font-weight: bold">SUB TOTAL :</span></td>
          <td align="right"><strong><?php echo number_format($totalsewa,0,',','.').",-";?></strong></td>
          <td align="right"><strong><?php echo number_format($totalbayar,0,',','.').",-";?></strong></td>
          <td align="right"><strong><?php echo number_format($totalsisa,0,',','.').",-";?></strong></td>
        </tr>
        
        <tr valign="top">
          <td colspan="11" align="left"><strong>SEWA KENDARAAN NON RETAIL</strong></td>
        </tr>
        <?php do { ?>
    <tr valign="top">
      <td align="left"><?php echo $row_datakorporate['marketing'];?></td>
	  <td height="47" align="left"><?php echo $row_datakorporate['mulai'];?></td>
      <td align="left"></a><?php echo $row_datakorporate['no_ref']; ?></td>
      <td><?php echo $row_datakorporate['kendaraan']; ?></td>
      <td><?php echo $row_datakorporate['merk'].'-'.$row_datakorporate['tipekendaraan']; ?></td>
       <td><?php echo $row_datakorporate['mulai']; ?></td>
      <td><?php echo $row_datakorporate['sampai']; ?></td>
      <td><?php echo $row_datakorporate['nama']; ?></td>      
      <td align="right"><?php echo number_format($row_datakorporate['total'],0,',','.').",-"; ?></td>
      <td align="right"><?php echo number_format($row_datakorporate['totalbayar'],0,',','.').",-"; ?></td>
      <td align="right"><?php echo number_format($row_datakorporate['sisakekurangan'],0,',','.').",-"; ?></td>
    </tr>
	<?php 
          $totalsewakorporate += $row_datakorporate['total'];
          $totalbayarkorporate += $row_datakorporate['totalbayar'];
          $totalpiutangkorporate += $row_datakorporate['sisakekurangan'];
        } while ($row_datakorporate = mysql_fetch_assoc($cekdatakorporate)); ?>
    <tr valign="top">
      <td colspan="8" align="center"><strong>SUBTOTAL</strong></td>
      <td align="right"><strong><?php echo number_format($totalsewakorporate,0,',','.').",-";?></strong></td>
      <td align="right"><strong><?php echo number_format($totalbayarkorporate,0,',','.').",-";?></strong></td>
      <td align="right"><strong><?php echo number_format($totalpiutangkorporate,0,',','.').",-";?></strong></td>
  </tr>
    <tr valign="top">
      <td colspan="8" align="right">&nbsp;</td>
      <td align="right">&nbsp;</td>
      <td align="right">&nbsp;</td>
      <td align="right">&nbsp;</td>
</tr>
   <tr valign="top">
      <td colspan="8" align="center"><strong>GRAND TOTAL</strong></td>
      <td align="right"><strong><?php echo number_format($totalsewa+$totalsewakorporate,0,',','.').",-";?></strong></td>
      <td align="right"><strong><?php echo number_format($totalbayar+$totalbayarkorporate,0,',','.').",-";?></strong></td>
      <td align="right"><strong><?php echo number_format($totalsisa+$totalpiutangkorporate,0,',','.').",-";?></strong></td>
  </tr>

  <tr class="hide">

    <td colspan="8"><?php if(strstr($_SESSION['akses'],"L-3")) { ?><?php } ?></td>
  </tr>
</table>

<?php

mysql_free_result($cr_gud);

?>

